![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
Analyze the ResultsThe final step is to analyze the results of any changes you have made. If the desired results have not been achieved, go back to the analysis stage to determine whether more tuning is necessary. You should always ask the question why? It is possible that the problem has been incorrectly identified or that you have not chosen the correct solution for that problem. Here are some questions to ask yourself during the analysis phase:
These are some examples of the types of questions you should ask yourself to determine whether the problem has been solvedor even affectedby the changes. You may have to go back and reanalyze the problem and try different things. Maybe you did not understand the problem correctly and have to add some additional debug code to the application to track down the problem. This five-step methodology leads to an analytical, logical way of viewing performance data. Using thisor anymethodology should lead you to the proper solution. SummaryDevelop a scientific approach to tuning and follow it. I prefer this five-step method:
This methodology may or may not work for you. If you prefer a different system, by all means use what works best for you. But use some sort of system or methodology for tuning. When following a tuning methodology like this, it is important that you take careful notes. If several iterations are done without careful notes, you may not be able to reproduce the results. I hope that this system works for you and helps you achieve great results. In any case, you now know the importance of having a systematic approach that includes good
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |